UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8gEucwHET/a8GD9gVOtnPN9DJuMkEkS9vGI1UNqS3PU='
WHERE
key_id = '0f4b3675cc457fef20a7cbb4d9fcb6a8f51d4784f409a4e83a4d339e7b1b42f3'
AND (
token = '8gEucwHET/a8GD9gVOtnPN9DJuMkEkS9vGI1UNqS3PU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)