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