UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Wp2Nc/kHWvGu7tKl0h0Kr91VoE1ZyVr8uAZGeBnOP38='
WHERE
key_id = 'bdafdb1d601ec013bbc3e0f16af26cea44327bd28698cc843f801704c699ff7a'
AND (
token = 'Wp2Nc/kHWvGu7tKl0h0Kr91VoE1ZyVr8uAZGeBnOP38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)