UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0kNt6VaNbkUZJd4MOojnciu6gz0a70rhjj9FBNdx7aE='
WHERE
key_id = 'b8abc08e3c11d52418d1059483cabc7cd7bea607e60cba00f94b4421300e64b3'
AND (
token = '0kNt6VaNbkUZJd4MOojnciu6gz0a70rhjj9FBNdx7aE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)