UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XIc0r973NaRwQhk8IuyNfzlbPYMW2H8QJCj2R6QyAWU='
WHERE
key_id = 'b7c1ec87ede6fc13c7155a63eded9cb4e7686ed2615d0411b9b457a17ac82d1e'
AND (
token = 'XIc0r973NaRwQhk8IuyNfzlbPYMW2H8QJCj2R6QyAWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)