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