UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X3BmGVr2fykHBT5nmP6k62xcWBFpizmNM+Gs3RnjbqE='
WHERE
key_id = 'bb6aaca6c78d653728bda5a237ecf39c741f37d50e1a14f756867da34be2953e'
AND (
token = 'X3BmGVr2fykHBT5nmP6k62xcWBFpizmNM+Gs3RnjbqE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)