UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wdCFBw4CJztrnWiPCJLXzteVVs63ASiGk72PowCxxOQ='
WHERE
key_id = 'b49e733f87e67ba0efa7dbebf710078f1d789240dc63d7f7c02f1406e3baf23a'
AND (
token = 'wdCFBw4CJztrnWiPCJLXzteVVs63ASiGk72PowCxxOQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)