UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KZ9rMoyehrcedkNoWJPteHFrJaZQGNCrv++0iG+TqpM='
WHERE
key_id = 'd29bc12752dc84646151d9fc1834c4e3553c1c1178b41adc161510135421ea1b'
AND (
token = 'KZ9rMoyehrcedkNoWJPteHFrJaZQGNCrv++0iG+TqpM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)