UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NKKxz3qs4jIPqddP0Fr2GigBeHV8Tw3bLUhYUA8Y0qk='
WHERE
key_id = '2ffdd1d58c531b9a447e72a21c28278ec54f6ec0b7ba48a3e281242ee6f77e0c'
AND (
token = 'NKKxz3qs4jIPqddP0Fr2GigBeHV8Tw3bLUhYUA8Y0qk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)