UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6mjEM8Fk8drZpH/DvfHsCkY6FUdkjL02Nom6CzcaJqg='
WHERE
key_id = '8e5e1c405847256011fbebee092b455f0c68e6dcf809aca8b58894fd24806eda'
AND (
token = '6mjEM8Fk8drZpH/DvfHsCkY6FUdkjL02Nom6CzcaJqg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)