UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0lKtQGfZ51Wnua8himIa7bWI0kR7YShf3/mCX+4Rs38='
WHERE
key_id = 'b5c98ac8f38105d1c71cad4a297fb65700b78f5364f0a9f00f7652195aaef924'
AND (
token = '0lKtQGfZ51Wnua8himIa7bWI0kR7YShf3/mCX+4Rs38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)