UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CyD45mQXboy5x67n3L/MuT0bHdKdK9Au090dxLsFcx8='
WHERE
key_id = 'ccbb44d6384240a063b83836cd55aa8da495d1f5957e48ebb7d419e9112e9b78'
AND (
token = 'CyD45mQXboy5x67n3L/MuT0bHdKdK9Au090dxLsFcx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)