UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'miaXLwxTuYfWtTVe4FOUZjvtfksE1QHQspdSWI7QW/w='
WHERE
key_id = 'd6128a88b3cab9cf89537a6eb7865f8e09bd41504c187fad31968d1f82ff6bc2'
AND (
token = 'miaXLwxTuYfWtTVe4FOUZjvtfksE1QHQspdSWI7QW/w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)