UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Swa1GsEY1btLZOvkf0PPRFl1QHbQPzsBu9VUI87pb0='
WHERE
key_id = 'fe842a3be31d7697aff3edfcdb0b46f523980a6c2981e7604b397da2bd3acad9'
AND (
token = '0Swa1GsEY1btLZOvkf0PPRFl1QHbQPzsBu9VUI87pb0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)