UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xgp1iW1NIwzWO8Uj0wSZmiCkU1gvFwl/h45MrHrXLM4='
WHERE
key_id = 'd81f9647281cec3f7b35db1fd27cf2c37f90ee4b44f94009da857203c1c98f22'
AND (
token = 'xgp1iW1NIwzWO8Uj0wSZmiCkU1gvFwl/h45MrHrXLM4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)