UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LcwK9B6ndCQvcocYce+ilPE+1wzp7VXwIAqhLU3EsNI='
WHERE
key_id = 'f2a0d85b86b6bf3614ff6a16442f659ec70c0d15744f980b492ed16cf55c46cb'
AND (
token = 'LcwK9B6ndCQvcocYce+ilPE+1wzp7VXwIAqhLU3EsNI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)