UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sW7tdqYitn3w/8jO3GONRAm/Kmd4foPLXw3vfZRocbQ='
WHERE
key_id = '71d7087a19d08c71d0d0888e2104a95fb4285f358c610fd0bbf3467b87373cea'
AND (
token = 'sW7tdqYitn3w/8jO3GONRAm/Kmd4foPLXw3vfZRocbQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)