UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6V8icHGtEv1AbMzhD533QroCH9IdAGkbnDtNEHUeKoc='
WHERE
key_id = '1d658bb516b3b1affa78cd7ced99432a60728957ef9baf51acf8b53b1679118a'
AND (
token = '6V8icHGtEv1AbMzhD533QroCH9IdAGkbnDtNEHUeKoc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)