UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pmLL7MF1TzHkgS46Fj5kXH7xzB1J5UnFxMUxQh7hmmk='
WHERE
key_id = '7e5dfb7590ed3f111618ff5ea40432301641bc97be8190bf0a7f47a67b567876'
AND (
token = 'pmLL7MF1TzHkgS46Fj5kXH7xzB1J5UnFxMUxQh7hmmk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)