UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '0D521r+QQD+QbxyG8aA+kI+UKVgZY8lUBs+hLXi7Bqo=' 
WHERE 
  key_id = 'c3f49be536d57f055f4e5f0e09c18f3de66c58bf0bf289ab4cadfe4bf283188f' 
  AND (
    token = '0D521r+QQD+QbxyG8aA+kI+UKVgZY8lUBs+hLXi7Bqo=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026