UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xq8GH5CSv3syw9h5gTxi5n6z+/N/QpETsDtTlLW+kxs='
WHERE
key_id = 'dfdc7afabe77ab39a17e92b6da60a4ba3727e413d09d2fdb006a9b3536e0c30e'
AND (
token = 'xq8GH5CSv3syw9h5gTxi5n6z+/N/QpETsDtTlLW+kxs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)