UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5oYvgIC6CdMd1ysUPiLNL3VtBjxSd9z5fiHGD/BEYpY='
WHERE
key_id = 'b456a02cec8f83d6274030f234100b06af37184e6be64f458ac388f276df0e9b'
AND (
token = '5oYvgIC6CdMd1ysUPiLNL3VtBjxSd9z5fiHGD/BEYpY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)