UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd7CMvVNpf7i86b/A6RoJ1KmFKRWVAzd46rVCiKX1WZI='
WHERE
key_id = '8c0bc6cb429b0f2f07f0913573dd3a419302fe1a4cc6d72eaeb12c083af8714a'
AND (
token = 'd7CMvVNpf7i86b/A6RoJ1KmFKRWVAzd46rVCiKX1WZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)