UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BozIzwRXPKD8yOv5zEVWRvnBXEcURvgqNO/yNs0K8Js='
WHERE
key_id = '535c1865b3b9e07dd2071e701b67a47b95e400a04b5b2c08a835250df3d81853'
AND (
token = 'BozIzwRXPKD8yOv5zEVWRvnBXEcURvgqNO/yNs0K8Js='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)