UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MC5d8uUW6960B0agRekBmsg9dNmTXxIVCJGh92+hpWY='
WHERE
key_id = '9e981d41b5fffec05076c7a191d728c92852b92b82e4c76179a0c46b1b15ff60'
AND (
token = 'MC5d8uUW6960B0agRekBmsg9dNmTXxIVCJGh92+hpWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)