UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D0Kk9riwUKr82ji031xlUApwq0wYcITmHskXtGM6fQQ='
WHERE
key_id = 'b8697a95d9c2db0b1e24293d6d33565eabadafabf524767ba6a2ab5680644e9e'
AND (
token = 'D0Kk9riwUKr82ji031xlUApwq0wYcITmHskXtGM6fQQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)