UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z9TzwQeJR5snxdvVpiAUP6Sv595L7Yd5v6Jk1wYp6KE='
WHERE
key_id = '99407ab8ba71557de10e20c2b81fa12efe0d124f5fdce8bba62581d0d41daea4'
AND (
token = 'z9TzwQeJR5snxdvVpiAUP6Sv595L7Yd5v6Jk1wYp6KE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)