UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hNjVHpwmzwfbmRHtdRNrzIm+8qOYMiI7ePeyH/vHREE='
WHERE
key_id = 'c72ca093f4d1abd069c15f39d9a12d6d000c687681a9c628b9804d0a881deefa'
AND (
token = 'hNjVHpwmzwfbmRHtdRNrzIm+8qOYMiI7ePeyH/vHREE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)