UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'm12EaWYTztGz9uvq5nK7IyAP3+f6J4c4zqsV0de4jCg='
WHERE
key_id = '8cfe831f5b1956890175bfc3daf3782ffff75cea557d3a230b8c0efee81e73b8'
AND (
token = 'm12EaWYTztGz9uvq5nK7IyAP3+f6J4c4zqsV0de4jCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)