UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4KBzmzT0ZU1AJumJL/Cyj1iTPJ2BEUGHSradeDzX5Ig='
WHERE
key_id = 'b5303c0b970156fe15a4b05a8da16785bdae6425a7aace5caf8ae2847f7c72d0'
AND (
token = '4KBzmzT0ZU1AJumJL/Cyj1iTPJ2BEUGHSradeDzX5Ig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)