UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sQLmberZJ/l0nSjyE5Nf7bkBol99qP+6DolaSYh73Y0='
WHERE
key_id = '96745aa108a5a3ed50ac389e3aa487c4574aa4bc5522cb93927ce84ede33562c'
AND (
token = 'sQLmberZJ/l0nSjyE5Nf7bkBol99qP+6DolaSYh73Y0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)