UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a1JaZY5zXkrfthaMtmObUL8TwbzV5L+eF6zR5SSNimc='
WHERE
key_id = 'c63a32d9e831adce70a696100180f9d94b5c9a78293b1cb728c21fd2efe01512'
AND (
token = 'a1JaZY5zXkrfthaMtmObUL8TwbzV5L+eF6zR5SSNimc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)