UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HoN2bjyH13G6+7NzyVomcvos3pLOtzTrmONl1na+fxw='
WHERE
key_id = 'af46fd058ee7ff502bf53bbc27124408dab431d5582831c8606b33a336bc8f93'
AND (
token = 'HoN2bjyH13G6+7NzyVomcvos3pLOtzTrmONl1na+fxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)