UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJdU2yUmF965NBPliMQWDSe5WB/Su4gPc33U25dgog0='
WHERE
key_id = 'd8d9fb6fea75711b81528c879fa45c8b685325ac8e95af19a5d9e9d9f783fad3'
AND (
token = 'zJdU2yUmF965NBPliMQWDSe5WB/Su4gPc33U25dgog0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)