UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QnYww7LJjC73jTNiLHXI6CUaBLOe8eYbohGt8b/IHSE='
WHERE
key_id = 'c06d6099cf397cc7cf4dd340eabb1debe6a9fa323f2aa45460eecc2087831723'
AND (
token = 'QnYww7LJjC73jTNiLHXI6CUaBLOe8eYbohGt8b/IHSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)