UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HnMpJB4dXJuad5nnsP/AYh33OE3QCvU7XBq8xIc404A='
WHERE
key_id = '1beca66814591bf7b354dddf55c84c5e45d7e82b05f3176c6c478bb3b4274d4b'
AND (
token = 'HnMpJB4dXJuad5nnsP/AYh33OE3QCvU7XBq8xIc404A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)