UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9bs3e8zOe48N8QoH2q4XpvFWhbAkhNcU7BXFO5pgpDM='
WHERE
key_id = '6bae57ba3e594645710182b36af30f1e915d07e16e9d9054a3607d181357397c'
AND (
token = '9bs3e8zOe48N8QoH2q4XpvFWhbAkhNcU7BXFO5pgpDM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)