UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k99TAfu1upVT2XDVqO1yg4T8J+5Hl3TooJaaZaqowC8='
WHERE
key_id = '9da00f5bca6a1ddbada0b1052db0406b0a086a9c2a17304a324c4f213810b349'
AND (
token = 'k99TAfu1upVT2XDVqO1yg4T8J+5Hl3TooJaaZaqowC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)