UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BtkMFAAM5o6i+AuP57bj7zWaCxuhIHnzqVKE7c9wMvQ='
WHERE
key_id = 'd96c3338e61dcf9a3eda01f9e2dd040082223c061308819414b38e220bb8974b'
AND (
token = 'BtkMFAAM5o6i+AuP57bj7zWaCxuhIHnzqVKE7c9wMvQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)