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